MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Artist Alpha Sort = 19552

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Object End Date, Medium, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
212399 48.10.3 0 1 339793 Drawings and Prints 11 Drawing 23 Nude           Artist 2   Suzanne Valadon French, Bessines-sur-Gartempe 1865–1938 Paris   Valadon, Suzanne 19552 French 2 1865 1938 n.d. 1880 1938 Black chalk (fixed) with touches of graphite 32132 9 11/16 x 7 1/2 in. (24.6 x 19.1 cm) Harris Brisbane Dick Fund, 1948                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
247695 2007.49.541 0 0 375989 Drawings and Prints 11 Print 731 Adéle préparant le tub et ketty aux bras levés           Artist 2   Suzanne Valadon French, Bessines-sur-Gartempe 1865–1938 Paris   Valadon, Suzanne 19552 French 2 1865 1938 1905 1905 1905 Etching 26137 plate: 9 3/8 x 10 5/8 in. (23.8 x 27 cm) sheet: 12 x 14 1/4 in. (30.5 x 36.2 cm) Bequest of William S. Lieberman, 2005                       Prints 13   Metropolitan Museum of Art, New York, NY 1
303229 1974.632 0 0 433071 Drawings and Prints 11 Print 731 Toilette de Enfants dans le Jardin           Artist 2   Suzanne Valadon French, Bessines-sur-Gartempe 1865–1938 Paris   Valadon, Suzanne 19552 French 2 1865 1938 1910 1910 1910 Drypoint 29360 13 5/8 × 15 3/8 in. (34.6 × 39.1 cm) Joseph Pulitzer Fund, and Elisha Whittelsey Fund, 1974                       Prints 13   Metropolitan Museum of Art, New York, NY 1
303238 68.673.9 0 0 433082 Drawings and Prints 11 Print 731 Woman Washing Young Boy           Artist 2   Suzanne Valadon French, Bessines-sur-Gartempe 1865–1938 Paris   Valadon, Suzanne 19552 French 2 1865 1938   1883 1938   15 3/8 × 12 in. (39.1 × 30.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1968                       Prints 13   Metropolitan Museum of Art, New York, NY 1
321927 1975.1.734 0 1 460078 Robert Lehman Collection 16 Drawing 23 After the Bath           Artist 2   Suzanne Valadon French, Bessines-sur-Gartempe 1865–1938 Paris   Valadon, Suzanne 19552 French 2 1865 1938 1893 1893 1893 Black crayon on tan wove paper (possibly lithograph transfer paper), back with white rice paper for conservation 48203 8 1/8 x 5 5/16 in. (20.6 x 13.5 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321928 1975.1.733 0 1 460079 Robert Lehman Collection 16 Drawing 23 Standing Nude           Artist 2   Suzanne Valadon French, Bessines-sur-Gartempe 1865–1938 Paris   Valadon, Suzanne 19552 French 2 1865 1938 1902 1902 1902 Red crayon on off-white laid paper 48204 12 3/16 x 11 in. (31.0 x 28 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321929 1975.1.735 0 1 460080 Robert Lehman Collection 16 Drawing 23 Before the Bath           Artist 2   Suzanne Valadon French, Bessines-sur-Gartempe 1865–1938 Paris   Valadon, Suzanne 19552 French 2 1865 1938 1908 1908 1908 Charcoal, colored and white chalk, with linear charcoal border on all edges, on dark buff wove paper mounted on board 48205 11 7/8 x 11 3/4 in. (30.2 x 29.8 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
323460 1975.1.214 0 1 461643 Robert Lehman Collection 16 Painting 69 Reclining Nude           Artist 2   Suzanne Valadon French, Bessines-sur-Gartempe 1865–1938 Paris   Valadon, Suzanne 19552 French 2 1865 1938 1928 1928 1928 Oil on canvas (lined) 48902 23 5/8 x 31 11/16 in. Robert Lehman Collection, 1975                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
341529 67.187.112 0 1 489550 Modern and Contemporary Art 4 Painting 69 Lilacs and Peonies           Artist 2   Suzanne Valadon French, Bessines-sur-Gartempe 1865–1938 Paris   Valadon, Suzanne 19552 French 2 1865 1938 1929 1929 1929 Oil on canvas 953 39 1/2 × 32 in. (100.3 × 81.3 cm) Bequest of Miss Adelaide Milton de Groot (1876-1967), 1967                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
341530 67.187.113 0 1 489551 Modern and Contemporary Art 4 Painting 69 Joy of Life           Artist 2   Suzanne Valadon French, Bessines-sur-Gartempe 1865–1938 Paris   Valadon, Suzanne 19552 French 2 1865 1938 1911 1911 1911 Oil on canvas 953 48 3/8 x 81 in. (122.9 x 205.7 cm) Bequest of Miss Adelaide Milton de Groot (1876-1967), 1967                       Paintings 11   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 117.941ms · Data license: CC0 · Data source: metmuseum/openaccess